Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 13903 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.4 MiB |
| Average record size in memory | 105.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 10 |
| Categorical | 1 |
ignore has constant value "" | Constant |
open is highly overall correlated with high and 7 other fields | High correlation |
high is highly overall correlated with open and 7 other fields | High correlation |
low is highly overall correlated with open and 7 other fields | High correlation |
close is highly overall correlated with open and 7 other fields | High correlation |
volume is highly overall correlated with open and 4 other fields | High correlation |
quote_asset_volume is highly overall correlated with open and 5 other fields | High correlation |
number_of_trades is highly overall correlated with open and 5 other fields | High correlation |
taker_buy_base_asset_volume is highly overall correlated with open and 4 other fields | High correlation |
taker_buy_quote_asset_volume is highly overall correlated with open and 5 other fields | High correlation |
volume is highly skewed (γ1 = 31.46906051) | Skewed |
taker_buy_base_asset_volume is highly skewed (γ1 = 31.67124314) | Skewed |
volume has unique values | Unique |
quote_asset_volume has unique values | Unique |
taker_buy_base_asset_volume has unique values | Unique |
taker_buy_quote_asset_volume has unique values | Unique |
Reproduction
| Analysis started | 2023-08-16 02:55:37.493871 |
|---|---|
| Analysis finished | 2023-08-16 02:56:01.756558 |
| Duration | 24.26 seconds |
| Software version | ydata-profiling vv4.5.0 |
| Download configuration | config.json |
timestamp
Date
| Distinct | 2052 |
|---|---|
| Distinct (%) | 14.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 230.3 KiB |
| Minimum | 2018-01-01 00:00:00 |
|---|---|
| Maximum | 2023-08-14 00:00:00 |
open
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 13192 |
|---|---|
| Distinct (%) | 94.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3310.9469 |
| Minimum | 0.0014971 |
|---|---|
| Maximum | 67525.82 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.3 KiB |
Quantile statistics
| Minimum | 0.0014971 |
|---|---|
| 5-th percentile | 0.037744 |
| Q1 | 0.293805 |
| median | 27.1106 |
| Q3 | 416.815 |
| 95-th percentile | 24284.345 |
| Maximum | 67525.82 |
| Range | 67525.819 |
| Interquartile range (IQR) | 416.52119 |
Descriptive statistics
| Standard deviation | 9640.5859 |
|---|---|
| Coefficient of variation (CV) | 2.9117307 |
| Kurtosis | 15.090699 |
| Mean | 3310.9469 |
| Median Absolute Deviation (MAD) | 27.06814 |
| Skewness | 3.8165071 |
| Sum | 46032095 |
| Variance | 92940897 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 317.1 | 4 | < 0.1% |
| 247.8 | 4 | < 0.1% |
| 246.2 | 4 | < 0.1% |
| 240.3 | 4 | < 0.1% |
| 0.07051 | 3 | < 0.1% |
| 0.4044 | 3 | < 0.1% |
| 240.7 | 3 | < 0.1% |
| 0.2993 | 3 | < 0.1% |
| 238.6 | 3 | < 0.1% |
| 0.0429 | 3 | < 0.1% |
| Other values (13182) | 13869 |
| Value | Count | Frequency (%) |
| 0.0014971 | 1 | |
| 0.0015927 | 1 | |
| 0.0016002 | 1 | |
| 0.0016219 | 1 | |
| 0.0016603 | 1 | |
| 0.0016903 | 1 | |
| 0.0017202 | 1 | |
| 0.0017222 | 1 | |
| 0.0017226 | 1 | |
| 0.00176 | 1 |
| Value | Count | Frequency (%) |
| 67525.82 | 1 | |
| 66947.67 | 1 | |
| 66001.4 | 1 | |
| 65519.11 | 1 | |
| 64882.42 | 1 | |
| 64774.25 | 1 | |
| 64380.01 | 1 | |
| 64280.59 | 1 | |
| 64122.22 | 1 | |
| 63606.73 | 1 |
high
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 12803 |
|---|---|
| Distinct (%) | 92.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3398.8724 |
| Minimum | 0.0016428 |
|---|---|
| Maximum | 69000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.3 KiB |
Quantile statistics
| Minimum | 0.0016428 |
|---|---|
| 5-th percentile | 0.0395 |
| Q1 | 0.303835 |
| median | 28.1797 |
| Q3 | 429.5 |
| 95-th percentile | 25010.853 |
| Maximum | 69000 |
| Range | 68999.998 |
| Interquartile range (IQR) | 429.19617 |
Descriptive statistics
| Standard deviation | 9896.679 |
|---|---|
| Coefficient of variation (CV) | 2.9117536 |
| Kurtosis | 15.072845 |
| Mean | 3398.8724 |
| Median Absolute Deviation (MAD) | 28.13578 |
| Skewness | 3.816884 |
| Sum | 47254523 |
| Variance | 97944255 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 245 | 6 | < 0.1% |
| 247 | 6 | < 0.1% |
| 292 | 5 | < 0.1% |
| 205 | 5 | < 0.1% |
| 248 | 4 | < 0.1% |
| 185 | 4 | < 0.1% |
| 0.135 | 4 | < 0.1% |
| 426 | 4 | < 0.1% |
| 244.9 | 4 | < 0.1% |
| 0.05 | 4 | < 0.1% |
| Other values (12793) | 13857 |
| Value | Count | Frequency (%) |
| 0.0016428 | 1 | |
| 0.0016873 | 1 | |
| 0.0017 | 1 | |
| 0.0017771 | 1 | |
| 0.0017957 | 1 | |
| 0.0018001 | 1 | |
| 0.001809 | 1 | |
| 0.0018286 | 1 | |
| 0.0018329 | 1 | |
| 0.0018395 | 1 |
| Value | Count | Frequency (%) |
| 69000 | 1 | |
| 68524.25 | 1 | |
| 67789 | 1 | |
| 67000 | 1 | |
| 66639.74 | 1 | |
| 66401.82 | 1 | |
| 65600.07 | 1 | |
| 65550.51 | 1 | |
| 65450.7 | 1 | |
| 65000 | 1 |
low
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 12744 |
|---|---|
| Distinct (%) | 91.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3212.1957 |
| Minimum | 0.0011345 |
|---|---|
| Maximum | 66222.4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.3 KiB |
Quantile statistics
| Minimum | 0.0011345 |
|---|---|
| 5-th percentile | 0.03624 |
| Q1 | 0.28175 |
| median | 25.9 |
| Q3 | 403.245 |
| 95-th percentile | 23763.02 |
| Maximum | 66222.4 |
| Range | 66222.399 |
| Interquartile range (IQR) | 402.96325 |
Descriptive statistics
| Standard deviation | 9350.2875 |
|---|---|
| Coefficient of variation (CV) | 2.9108711 |
| Kurtosis | 15.063509 |
| Mean | 3212.1957 |
| Median Absolute Deviation (MAD) | 25.85873 |
| Skewness | 3.8115795 |
| Sum | 44659156 |
| Variance | 87427877 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.3 | 6 | < 0.1% |
| 0.12 | 5 | < 0.1% |
| 242 | 5 | < 0.1% |
| 0.28 | 5 | < 0.1% |
| 0.235 | 5 | < 0.1% |
| 0.082 | 5 | < 0.1% |
| 9.81 | 4 | < 0.1% |
| 0.0024 | 4 | < 0.1% |
| 0.3486 | 4 | < 0.1% |
| 273.2 | 4 | < 0.1% |
| Other values (12734) | 13856 |
| Value | Count | Frequency (%) |
| 0.0011345 | 1 | |
| 0.0013478 | 1 | |
| 0.0014003 | 1 | |
| 0.0015442 | 1 | |
| 0.001546 | 1 | |
| 0.001565 | 1 | |
| 0.0016295 | 1 | |
| 0.001633 | 1 | |
| 0.0016412 | 1 | |
| 0.0016843 | 1 |
| Value | Count | Frequency (%) |
| 66222.4 | 1 | |
| 64100 | 1 | |
| 63576.27 | 1 | |
| 63481.4 | 1 | |
| 63400 | 1 | |
| 63360.22 | 1 | |
| 63273.58 | 1 | |
| 62822.9 | 1 | |
| 62278 | 1 | |
| 62020 | 1 |
close
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 13179 |
|---|---|
| Distinct (%) | 94.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3312.1872 |
| Minimum | 0.0015817 |
|---|---|
| Maximum | 67525.83 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.3 KiB |
Quantile statistics
| Minimum | 0.0015817 |
|---|---|
| 5-th percentile | 0.037932 |
| Q1 | 0.29394 |
| median | 27.1181 |
| Q3 | 416.745 |
| 95-th percentile | 24303.282 |
| Maximum | 67525.83 |
| Range | 67525.828 |
| Interquartile range (IQR) | 416.45106 |
Descriptive statistics
| Standard deviation | 9642.7374 |
|---|---|
| Coefficient of variation (CV) | 2.91129 |
| Kurtosis | 15.076802 |
| Mean | 3312.1872 |
| Median Absolute Deviation (MAD) | 27.07567 |
| Skewness | 3.8149714 |
| Sum | 46049338 |
| Variance | 92982386 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.0836 | 4 | < 0.1% |
| 244.5 | 4 | < 0.1% |
| 290.4 | 4 | < 0.1% |
| 0.3126 | 4 | < 0.1% |
| 44.98 | 4 | < 0.1% |
| 244.3 | 3 | < 0.1% |
| 13.71 | 3 | < 0.1% |
| 0.4662 | 3 | < 0.1% |
| 148.1 | 3 | < 0.1% |
| 0.06845 | 3 | < 0.1% |
| Other values (13169) | 13868 |
| Value | Count | Frequency (%) |
| 0.0015817 | 1 | |
| 0.0015996 | 1 | |
| 0.0016002 | 1 | |
| 0.0016219 | 1 | |
| 0.0016632 | 1 | |
| 0.0016932 | 1 | |
| 0.0017099 | 1 | |
| 0.0017264 | 1 | |
| 0.001746 | 1 | |
| 0.00177 | 1 |
| Value | Count | Frequency (%) |
| 67525.83 | 1 | |
| 66947.66 | 1 | |
| 66001.41 | 1 | |
| 65519.1 | 1 | |
| 64882.43 | 1 | |
| 64774.26 | 1 | |
| 64380 | 1 | |
| 64280.59 | 1 | |
| 64122.23 | 1 | |
| 63606.74 | 1 |
volume
Real number (ℝ)
HIGH CORRELATION  SKEWED  UNIQUE 
| Distinct | 13903 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4455328 Ă— 108 |
| Minimum | 30.208 |
|---|---|
| Maximum | 1.0907369 Ă— 1011 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.3 KiB |
Quantile statistics
| Minimum | 30.208 |
|---|---|
| 5-th percentile | 3602.3168 |
| Q1 | 148748.12 |
| median | 973857.75 |
| Q3 | 15834297 |
| 95-th percentile | 9.1839877 Ă— 108 |
| Maximum | 1.0907369 Ă— 1011 |
| Range | 1.0907369 Ă— 1011 |
| Interquartile range (IQR) | 15685549 |
Descriptive statistics
| Standard deviation | 1.9746319 Ă— 109 |
|---|---|
| Coefficient of variation (CV) | 8.0744446 |
| Kurtosis | 1388.1154 |
| Mean | 2.4455328 Ă— 108 |
| Median Absolute Deviation (MAD) | 948428.89 |
| Skewness | 31.469061 |
| Sum | 3.4000242 Ă— 1012 |
| Variance | 3.8991712 Ă— 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8609.915844 | 1 | < 0.1% |
| 1155338.3 | 1 | < 0.1% |
| 1034314.7 | 1 | < 0.1% |
| 3867340.7 | 1 | < 0.1% |
| 1751137.1 | 1 | < 0.1% |
| 1532868 | 1 | < 0.1% |
| 2297658.9 | 1 | < 0.1% |
| 2331073.1 | 1 | < 0.1% |
| 1677351.6 | 1 | < 0.1% |
| 1595838.8 | 1 | < 0.1% |
| Other values (13893) | 13893 |
| Value | Count | Frequency (%) |
| 30.208 | 1 | |
| 138.3421 | 1 | |
| 175.905 | 1 | |
| 229.57441 | 1 | |
| 254.93685 | 1 | |
| 266.78477 | 1 | |
| 283.11115 | 1 | |
| 285.42792 | 1 | |
| 290.3541 | 1 | |
| 296.43034 | 1 |
| Value | Count | Frequency (%) |
| 1.090736932 Ă— 1011 | 1 | |
| 1.029897951 Ă— 1011 | 1 | |
| 5.751054536 Ă— 1010 | 1 | |
| 5.455938857 Ă— 1010 | 1 | |
| 4.879564252 Ă— 1010 | 1 | |
| 4.633334726 Ă— 1010 | 1 | |
| 4.457779773 Ă— 1010 | 1 | |
| 3.88378463 Ă— 1010 | 1 | |
| 3.668098972 Ă— 1010 | 1 | |
| 2.964880892 Ă— 1010 | 1 |
close_time
Real number (ℝ)
| Distinct | 2057 |
|---|---|
| Distinct (%) | 14.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6091968 Ă— 1012 |
| Minimum | 1.5148512 Ă— 1012 |
|---|---|
| Maximum | 1.6920576 Ă— 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.3 KiB |
Quantile statistics
| Minimum | 1.5148512 Ă— 1012 |
|---|---|
| 5-th percentile | 1.5321312 Ă— 1012 |
| Q1 | 1.570968 Ă— 1012 |
| median | 1.6093728 Ă— 1012 |
| Q3 | 1.6479072 Ă— 1012 |
| 95-th percentile | 1.6844544 Ă— 1012 |
| Maximum | 1.6920576 Ă— 1012 |
| Range | 1.772064 Ă— 1011 |
| Interquartile range (IQR) | 7.69392 Ă— 1010 |
Descriptive statistics
| Standard deviation | 4.7030976 Ă— 1010 |
|---|---|
| Coefficient of variation (CV) | 0.029226368 |
| Kurtosis | -1.0309898 |
| Mean | 1.6091968 Ă— 1012 |
| Median Absolute Deviation (MAD) | 3.8448 Ă— 1010 |
| Skewness | -0.032238616 |
| Sum | 2.2372663 Ă— 1016 |
| Variance | 2.2119127 Ă— 1021 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.6036704 Ă— 1012 | 8 | 0.1% |
| 1.6003008 Ă— 1012 | 8 | 0.1% |
| 1.600992 Ă— 1012 | 8 | 0.1% |
| 1.6009056 Ă— 1012 | 8 | 0.1% |
| 1.6008192 Ă— 1012 | 8 | 0.1% |
| 1.6007328 Ă— 1012 | 8 | 0.1% |
| 1.6006464 Ă— 1012 | 8 | 0.1% |
| 1.60056 Ă— 1012 | 8 | 0.1% |
| 1.6004736 Ă— 1012 | 8 | 0.1% |
| 1.6003872 Ă— 1012 | 8 | 0.1% |
| Other values (2047) | 13823 |
| Value | Count | Frequency (%) |
| 1.5148512 Ă— 1012 | 3 | |
| 1.5149376 Ă— 1012 | 3 | |
| 1.515024 Ă— 1012 | 3 | |
| 1.5151104 Ă— 1012 | 3 | |
| 1.5151968 Ă— 1012 | 3 | |
| 1.5152832 Ă— 1012 | 3 | |
| 1.5153696 Ă— 1012 | 3 | |
| 1.515456 Ă— 1012 | 3 | |
| 1.5155424 Ă— 1012 | 3 | |
| 1.5156288 Ă— 1012 | 3 |
| Value | Count | Frequency (%) |
| 1.6920576 Ă— 1012 | 8 | |
| 1.6919712 Ă— 1012 | 8 | |
| 1.6918848 Ă— 1012 | 8 | |
| 1.6917984 Ă— 1012 | 8 | |
| 1.691712 Ă— 1012 | 8 | |
| 1.6916256 Ă— 1012 | 8 | |
| 1.6915392 Ă— 1012 | 8 | |
| 1.6914528 Ă— 1012 | 8 | |
| 1.6913664 Ă— 1012 | 8 | |
| 1.69128 Ă— 1012 | 8 |
quote_asset_volume
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 13903 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.729724 Ă— 108 |
| Minimum | 1364.507 |
|---|---|
| Maximum | 1.7598562 Ă— 1010 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.3 KiB |
Quantile statistics
| Minimum | 1364.507 |
|---|---|
| 5-th percentile | 72625.635 |
| Q1 | 1650088.7 |
| median | 62576189 |
| Q3 | 3.3785556 Ă— 108 |
| 95-th percentile | 2.4754624 Ă— 109 |
| Maximum | 1.7598562 Ă— 1010 |
| Range | 1.759856 Ă— 1010 |
| Interquartile range (IQR) | 3.3620547 Ă— 108 |
Descriptive statistics
| Standard deviation | 1.1477513 Ă— 109 |
|---|---|
| Coefficient of variation (CV) | 2.4266772 |
| Kurtosis | 38.66932 |
| Mean | 4.729724 Ă— 108 |
| Median Absolute Deviation (MAD) | 62396832 |
| Skewness | 5.1195865 |
| Sum | 6.5757353 Ă— 1012 |
| Variance | 1.3173331 Ă— 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 114799747.4 | 1 | < 0.1% |
| 379218.5199 | 1 | < 0.1% |
| 366245.9354 | 1 | < 0.1% |
| 1430689.347 | 1 | < 0.1% |
| 630906.3538 | 1 | < 0.1% |
| 541676.0518 | 1 | < 0.1% |
| 819621.0482 | 1 | < 0.1% |
| 842090.4445 | 1 | < 0.1% |
| 612038.1226 | 1 | < 0.1% |
| 579719.9926 | 1 | < 0.1% |
| Other values (13893) | 13893 |
| Value | Count | Frequency (%) |
| 1364.506957 | 1 | |
| 1439.04689 | 1 | |
| 1583.539436 | 1 | |
| 1632.474886 | 1 | |
| 1763.6767 | 1 | |
| 1801.183385 | 1 | |
| 1937.348977 | 1 | |
| 1964.217308 | 1 | |
| 2301.256112 | 1 | |
| 2367.736699 | 1 |
| Value | Count | Frequency (%) |
| 1.759856186 Ă— 1010 | 1 | |
| 1.74653071 Ă— 1010 | 1 | |
| 1.647668107 Ă— 1010 | 1 | |
| 1.582499608 Ă— 1010 | 1 | |
| 1.475838431 Ă— 1010 | 1 | |
| 1.429100574 Ă— 1010 | 1 | |
| 1.370074615 Ă— 1010 | 1 | |
| 1.347769493 Ă— 1010 | 1 | |
| 1.330042454 Ă— 1010 | 1 | |
| 1.27377197 Ă— 1010 | 1 |
number_of_trades
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 12120 |
|---|---|
| Distinct (%) | 87.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 459063.37 |
| Minimum | 4 |
|---|---|
| Maximum | 15330777 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.3 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 207 |
| Q1 | 5241 |
| median | 129247 |
| Q3 | 443478 |
| 95-th percentile | 1785232.4 |
| Maximum | 15330777 |
| Range | 15330773 |
| Interquartile range (IQR) | 438237 |
Descriptive statistics
| Standard deviation | 1047767 |
|---|---|
| Coefficient of variation (CV) | 2.2824016 |
| Kurtosis | 46.647728 |
| Mean | 459063.37 |
| Median Absolute Deviation (MAD) | 128498 |
| Skewness | 5.8385057 |
| Sum | 6.382358 Ă— 109 |
| Variance | 1.0978156 Ă— 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 66 | 13 | 0.1% |
| 55 | 11 | 0.1% |
| 77 | 9 | 0.1% |
| 75 | 9 | 0.1% |
| 282 | 9 | 0.1% |
| 194 | 9 | 0.1% |
| 377 | 8 | 0.1% |
| 284 | 8 | 0.1% |
| 243 | 8 | 0.1% |
| 655 | 8 | 0.1% |
| Other values (12110) | 13811 |
| Value | Count | Frequency (%) |
| 4 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 22 | 2 | |
| 23 | 3 | |
| 24 | 4 |
| Value | Count | Frequency (%) |
| 15330777 | 1 | |
| 15223589 | 1 | |
| 14820760 | 1 | |
| 14530601 | 1 | |
| 13605474 | 1 | |
| 13113359 | 1 | |
| 12719887 | 1 | |
| 12613034 | 1 | |
| 12106261 | 1 | |
| 11885014 | 1 |
taker_buy_base_asset_volume
Real number (ℝ)
HIGH CORRELATION  SKEWED  UNIQUE 
| Distinct | 13903 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2163826 Ă— 108 |
| Minimum | 30.068 |
|---|---|
| Maximum | 5.419393 Ă— 1010 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.3 KiB |
Quantile statistics
| Minimum | 30.068 |
|---|---|
| 5-th percentile | 1706.3379 |
| Q1 | 72657.92 |
| median | 477028.87 |
| Q3 | 8041185.1 |
| 95-th percentile | 4.5399713 Ă— 108 |
| Maximum | 5.419393 Ă— 1010 |
| Range | 5.419393 Ă— 1010 |
| Interquartile range (IQR) | 7968527.1 |
Descriptive statistics
| Standard deviation | 9.8897795 Ă— 108 |
|---|---|
| Coefficient of variation (CV) | 8.1304843 |
| Kurtosis | 1401.9053 |
| Mean | 1.2163826 Ă— 108 |
| Median Absolute Deviation (MAD) | 464315.68 |
| Skewness | 31.671243 |
| Sum | 1.6911367 Ă— 1012 |
| Variance | 9.7807738 Ă— 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3961.938946 | 1 | < 0.1% |
| 609355.2 | 1 | < 0.1% |
| 554677.6 | 1 | < 0.1% |
| 1695824.5 | 1 | < 0.1% |
| 560013.9 | 1 | < 0.1% |
| 537692.3 | 1 | < 0.1% |
| 1132652.2 | 1 | < 0.1% |
| 1393904.7 | 1 | < 0.1% |
| 702840.6 | 1 | < 0.1% |
| 734217.3 | 1 | < 0.1% |
| Other values (13893) | 13893 |
| Value | Count | Frequency (%) |
| 30.068 | 1 | |
| 61.22485 | 1 | |
| 65.75459 | 1 | |
| 71.46 | 1 | |
| 74.4858 | 1 | |
| 75.12533 | 1 | |
| 99.72737 | 1 | |
| 102.10344 | 1 | |
| 103.27294 | 1 | |
| 103.617 | 1 |
| Value | Count | Frequency (%) |
| 5.419393024 Ă— 1010 | 1 | |
| 5.236644697 Ă— 1010 | 1 | |
| 2.942236996 Ă— 1010 | 1 | |
| 2.675672206 Ă— 1010 | 1 | |
| 2.476810586 Ă— 1010 | 1 | |
| 2.307243258 Ă— 1010 | 1 | |
| 2.217160585 Ă— 1010 | 1 | |
| 1.98756494 Ă— 1010 | 1 | |
| 1.825278002 Ă— 1010 | 1 | |
| 1.461480517 Ă— 1010 | 1 |
taker_buy_quote_asset_volume
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 13903 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.3518263 Ă— 108 |
| Minimum | 159.20869 |
|---|---|
| Maximum | 9.0139691 Ă— 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.3 KiB |
Quantile statistics
| Minimum | 159.20869 |
|---|---|
| 5-th percentile | 30401.883 |
| Q1 | 807559.99 |
| median | 31110941 |
| Q3 | 1.67947 Ă— 108 |
| 95-th percentile | 1.2333995 Ă— 109 |
| Maximum | 9.0139691 Ă— 109 |
| Range | 9.0139689 Ă— 109 |
| Interquartile range (IQR) | 1.6713944 Ă— 108 |
Descriptive statistics
| Standard deviation | 5.7047871 Ă— 108 |
|---|---|
| Coefficient of variation (CV) | 2.4256838 |
| Kurtosis | 39.588393 |
| Mean | 2.3518263 Ă— 108 |
| Median Absolute Deviation (MAD) | 31035458 |
| Skewness | 5.1585899 |
| Sum | 3.2697442 Ă— 1012 |
| Variance | 3.2544596 Ă— 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 52809747.44 | 1 | < 0.1% |
| 200046.0177 | 1 | < 0.1% |
| 196679.8594 | 1 | < 0.1% |
| 624913.0839 | 1 | < 0.1% |
| 201712.5501 | 1 | < 0.1% |
| 190535.4904 | 1 | < 0.1% |
| 404311.5378 | 1 | < 0.1% |
| 502489.4079 | 1 | < 0.1% |
| 257527.1946 | 1 | < 0.1% |
| 267323.0486 | 1 | < 0.1% |
| Other values (13893) | 13893 |
| Value | Count | Frequency (%) |
| 159.208694 | 1 | |
| 229.248615 | 1 | |
| 255.400341 | 1 | |
| 316.991198 | 1 | |
| 582.694168 | 1 | |
| 591.952679 | 1 | |
| 627.613604 | 1 | |
| 638.874535 | 1 | |
| 693.209687 | 1 | |
| 702.733383 | 1 |
| Value | Count | Frequency (%) |
| 9013969075 | 1 | |
| 8783916248 | 1 | |
| 8392477832 | 1 | |
| 7976620082 | 1 | |
| 7271200924 | 1 | |
| 7157472157 | 1 | |
| 6724156565 | 1 | |
| 6680704888 | 1 | |
| 6410032517 | 1 | |
| 6245795115 | 1 |
ignore
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 230.3 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 13903 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 13903 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 13903 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 13903 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 13903 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 13903 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 13903 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 13903 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 13903 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 13903 |
| open | high | low | close | volume | close_time | quote_asset_volume | number_of_trades | taker_buy_base_asset_volume | taker_buy_quote_asset_volume | |
|---|---|---|---|---|---|---|---|---|---|---|
| open | 1.000 | 1.000 | 1.000 | 1.000 | -0.685 | 0.131 | 0.662 | 0.619 | -0.674 | 0.663 |
| high | 1.000 | 1.000 | 1.000 | 1.000 | -0.683 | 0.130 | 0.664 | 0.621 | -0.672 | 0.666 |
| low | 1.000 | 1.000 | 1.000 | 1.000 | -0.686 | 0.131 | 0.661 | 0.617 | -0.675 | 0.662 |
| close | 1.000 | 1.000 | 1.000 | 1.000 | -0.684 | 0.131 | 0.663 | 0.619 | -0.673 | 0.664 |
| volume | -0.685 | -0.683 | -0.686 | -0.684 | 1.000 | 0.114 | 0.038 | 0.087 | 0.998 | 0.035 |
| close_time | 0.131 | 0.130 | 0.131 | 0.131 | 0.114 | 1.000 | 0.323 | 0.342 | 0.117 | 0.320 |
| quote_asset_volume | 0.662 | 0.664 | 0.661 | 0.663 | 0.038 | 0.323 | 1.000 | 0.990 | 0.049 | 0.999 |
| number_of_trades | 0.619 | 0.621 | 0.617 | 0.619 | 0.087 | 0.342 | 0.990 | 1.000 | 0.097 | 0.989 |
| taker_buy_base_asset_volume | -0.674 | -0.672 | -0.675 | -0.673 | 0.998 | 0.117 | 0.049 | 0.097 | 1.000 | 0.049 |
| taker_buy_quote_asset_volume | 0.663 | 0.666 | 0.662 | 0.664 | 0.035 | 0.320 | 0.999 | 0.989 | 0.049 | 1.000 |
| timestamp | open | high | low | close | volume | close_time | quote_asset_volume | number_of_trades | taker_buy_base_asset_volume | taker_buy_quote_asset_volume | ignore | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BTCUSDT | 0 | 2018-01-01 | 13715.65 | 13818.55 | 12750.00 | 13380.00 | 8609.915844 | 1514851199999 | 1.147997e+08 | 105595.0 | 3961.938946 | 5.280975e+07 | 0 |
| 1 | 2018-01-02 | 13382.16 | 15473.49 | 12890.02 | 14675.11 | 20078.092111 | 1514937599999 | 2.797171e+08 | 177728.0 | 11346.326739 | 1.580801e+08 | 0 | |
| 2 | 2018-01-03 | 14690.00 | 15307.56 | 14150.00 | 14919.51 | 15905.667639 | 1515023999999 | 2.361169e+08 | 162787.0 | 8994.953566 | 1.335873e+08 | 0 | |
| 3 | 2018-01-04 | 14919.51 | 15280.00 | 13918.04 | 15059.54 | 21329.649574 | 1515110399999 | 3.127816e+08 | 170310.0 | 12680.812951 | 1.861168e+08 | 0 | |
| 4 | 2018-01-05 | 15059.56 | 17176.24 | 14600.00 | 16960.39 | 23251.491125 | 1515196799999 | 3.693220e+08 | 192969.0 | 13346.622293 | 2.118299e+08 | 0 | |
| 5 | 2018-01-06 | 16960.39 | 17143.13 | 16011.21 | 17069.79 | 18571.457508 | 1515283199999 | 3.092169e+08 | 158242.0 | 11007.164056 | 1.834178e+08 | 0 | |
| 6 | 2018-01-07 | 17069.79 | 17099.96 | 15610.00 | 16150.03 | 12493.125558 | 1515369599999 | 2.061947e+08 | 120269.0 | 6779.320508 | 1.121512e+08 | 0 | |
| 7 | 2018-01-08 | 16218.85 | 16322.30 | 12812.00 | 14902.54 | 26600.609912 | 1515455999999 | 3.965700e+08 | 208642.0 | 13756.844389 | 2.060496e+08 | 0 | |
| 8 | 2018-01-09 | 14902.54 | 15500.00 | 14011.05 | 14400.00 | 14315.004253 | 1515542399999 | 2.106302e+08 | 156656.0 | 6841.233287 | 1.006986e+08 | 0 | |
| 9 | 2018-01-10 | 14401.00 | 14955.66 | 13131.31 | 14907.09 | 17411.001655 | 1515628799999 | 2.440114e+08 | 161476.0 | 8529.554675 | 1.195701e+08 | 0 |
| timestamp | open | high | low | close | volume | close_time | quote_asset_volume | number_of_trades | taker_buy_base_asset_volume | taker_buy_quote_asset_volume | ignore | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DOGEUSDT | 1492 | 2023-08-05 | 0.07346 | 0.07708 | 0.07292 | 0.07571 | 1.062980e+09 | 1691279999999 | 8.036190e+07 | 156317.0 | 545409723.0 | 4.124821e+07 | 0 |
| 1493 | 2023-08-06 | 0.07572 | 0.07649 | 0.07407 | 0.07427 | 6.672252e+08 | 1691366399999 | 5.016737e+07 | 101876.0 | 326758910.0 | 2.457553e+07 | 0 | |
| 1494 | 2023-08-07 | 0.07427 | 0.07573 | 0.07170 | 0.07354 | 6.860242e+08 | 1691452799999 | 5.066166e+07 | 113898.0 | 310617392.0 | 2.296354e+07 | 0 | |
| 1495 | 2023-08-08 | 0.07354 | 0.07548 | 0.07321 | 0.07496 | 5.735745e+08 | 1691539199999 | 4.264991e+07 | 91886.0 | 274952081.0 | 2.045537e+07 | 0 | |
| 1496 | 2023-08-09 | 0.07497 | 0.07622 | 0.07419 | 0.07541 | 4.948366e+08 | 1691625599999 | 3.722041e+07 | 80476.0 | 234370475.0 | 1.762911e+07 | 0 | |
| 1497 | 2023-08-10 | 0.07542 | 0.07695 | 0.07514 | 0.07588 | 6.145324e+08 | 1691711999999 | 4.664747e+07 | 101988.0 | 315622223.0 | 2.396316e+07 | 0 | |
| 1498 | 2023-08-11 | 0.07587 | 0.07611 | 0.07484 | 0.07574 | 3.037878e+08 | 1691798399999 | 2.295508e+07 | 51419.0 | 139078876.0 | 1.051290e+07 | 0 | |
| 1499 | 2023-08-12 | 0.07574 | 0.07745 | 0.07561 | 0.07670 | 5.880606e+08 | 1691884799999 | 4.505888e+07 | 84459.0 | 316164628.0 | 2.423127e+07 | 0 | |
| 1500 | 2023-08-13 | 0.07670 | 0.07689 | 0.07430 | 0.07479 | 4.685280e+08 | 1691971199999 | 3.548866e+07 | 71384.0 | 212851900.0 | 1.612911e+07 | 0 | |
| 1501 | 2023-08-14 | 0.07479 | 0.07711 | 0.07365 | 0.07469 | 7.796326e+08 | 1692057599999 | 5.847326e+07 | 121040.0 | 340949124.0 | 2.559942e+07 | 0 |